Tabela TimeAxis

Definicja tabeli TimeAxis

Name

TimeAxis

Code

TimeAxis

Comment

Os czasu


Lista kolumn tabeli TimeAxis

Name

Code

TimeAxisID

TimeAxisID

Month

Month

Quarter

Quarter

Halfyear

Halfyear

Year

Year

Name

Name

StartDT

StartDT

StopDT

StopDT


Kolumna TimeAxisID tabeli TimeAxis

Definicja kolumny TimeAxisID tabeli TimeAxis

Name

TimeAxisID

Code

TimeAxisID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID punktu na osi czasu


Kolumna Month tabeli TimeAxis

Definicja kolumny Month tabeli TimeAxis

Name

Month

Code

Month

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Miesiac


Kolumna Quarter tabeli TimeAxis

Definicja kolumny Quarter tabeli TimeAxis

Name

Quarter

Code

Quarter

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Kwartal


Kolumna Halfyear tabeli TimeAxis

Definicja kolumny Halfyear tabeli TimeAxis

Name

Halfyear

Code

Halfyear

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Pólrocze


Kolumna Year tabeli TimeAxis

Definicja kolumny Year tabeli TimeAxis

Name

Year

Code

Year

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Rok


Kolumna Name tabeli TimeAxis

Definicja kolumny Name tabeli TimeAxis

Name

Name

Code

Name

Data Type

VARCHAR2(20)

Mandatory

Yes

Comment

Nazwa


Kolumna StartDT tabeli TimeAxis

Definicja kolumny StartDT tabeli TimeAxis

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Poczatek okresu


Kolumna StopDT tabeli TimeAxis

Definicja kolumny StopDT tabeli TimeAxis

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Koniec okresu


Lista kluczy tabeli TimeAxis

Name

Code

Primary

PK_TIMEAXIS

PK_TIMEAXIS

X


Klucz PK_TIMEAXIS tabeli TimeAxis

Definicja klucza PK_TIMEAXIS tabeli TimeAxis

Name

PK_TIMEAXIS

Code

PK_TIMEAXIS

Primary

Yes

Comment